Insert Image

Excel.InsertImage(objExcelWorkBook,sheet,sFilePath,sName,fLeft,fTop,fWidth,fHeight)

Insert an image in the sheet. If the specified image name already exists, replace the existing image

Required Parameter: objExcelWorkBook--Excel workbook object (workbook opened with "Open Excel" command (Excel.OpenExcel)); sheet--If a string is used, it refers to the name of the specified sheet; if a number is used, it refers to the index of the specified sheet (starting from 0); sFilePath--Path to the image file to insert; sName--The default value is an empty string, which is automatically orchestrated by Excel. To delete or update the image, it is recommended to change the name; fLeft--The margin to the left of the image; fTop--The margin to the top of the image; fWidth--The width of the image, calculated as percentage of the original image; fHeight--The Height of the image, calculated as percentage of the original image

results matching ""